UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sbvQFpayddczWtTfkVvYEyM5Fg8e9k7ZwWqYmw5bxYA=' 
WHERE 
  key_id = 'ba17d9c2c289d66ea3fbf3494865680c01f0d0eb00aba4c6a11f05d6f537046e' 
  AND (
    token = 'sbvQFpayddczWtTfkVvYEyM5Fg8e9k7ZwWqYmw5bxYA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036