UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QUu+CXlASJnQ8gbNCDO7T5oW5wb48ST/PbSIKsC1/yQ=' 
WHERE 
  key_id = '8d2e265f44821947c27a986e9b3c7b22c6b4c549a0d156914590c31c0c46f48a' 
  AND (
    token = 'QUu+CXlASJnQ8gbNCDO7T5oW5wb48ST/PbSIKsC1/yQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021