UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7pZnW4CW1R1qobD0tQqbQ9m7YlaRUhfK6nGlO+y1Rlk=' 
WHERE 
  key_id = '9b91fad1dd681ee1e453905914d7afd79bc6b856fa046a4351ce9bcf8ee1d674' 
  AND (
    token = '7pZnW4CW1R1qobD0tQqbQ9m7YlaRUhfK6nGlO+y1Rlk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043