UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'j9VXhr24IO9X5KoeA4fkefKk5eWGg6N0gV3I+2ghyrA=' 
WHERE 
  key_id = '34ef97fee0c60de1b93b86b4911af4dc21a67c22a459564a890b53bc4808e33f' 
  AND (
    token = 'j9VXhr24IO9X5KoeA4fkefKk5eWGg6N0gV3I+2ghyrA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021