UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FD+JSW8rNJxzIiJiUeXN1nV7uNV5U3gu0BV81tOIrs0=' 
WHERE 
  key_id = '7c66242f13c8b7ec97eea5dcd2e0aeba1bba3daa4669a30ca297b0da3ba591bd' 
  AND (
    token = 'FD+JSW8rNJxzIiJiUeXN1nV7uNV5U3gu0BV81tOIrs0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025