UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fPW7MMsndt406Y6/xVr7ExOdYtEnEaKu2qzGxGPgUY0=' 
WHERE 
  key_id = '1f69f5bc9005d5a48c8652e41a781634f4b90b2f5e94913ae9fd95435f86f83d' 
  AND (
    token = 'fPW7MMsndt406Y6/xVr7ExOdYtEnEaKu2qzGxGPgUY0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033