UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2qK2zSVEH/tBd618WHNziz2jwGr6QHx/X39Zh+QMT5o=' 
WHERE 
  key_id = 'f9a3becac9a69531ac1533666b67f2ea7ad5fb3baf29241da10672cd7a7c5beb' 
  AND (
    token = '2qK2zSVEH/tBd618WHNziz2jwGr6QHx/X39Zh+QMT5o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034