UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LQPgS5h/JoyQnHz8f4dC2URjXXCtJuVkjkEvxmOktRw=' 
WHERE 
  key_id = 'f9ae69452c27d9221af39a45d4f348046437fe29bc7f3286d20463bcf8f3adbf' 
  AND (
    token = 'LQPgS5h/JoyQnHz8f4dC2URjXXCtJuVkjkEvxmOktRw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030