UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '56ByJwHKk0hAkaRFzMmQhvvl+kjXpQGmwZcpbOgmQ/g=' 
WHERE 
  key_id = 'effad4d34b76d7d0b2e5560ac14fd22f93c5376b6b8bbaa786dda1eb0f57637a' 
  AND (
    token = '56ByJwHKk0hAkaRFzMmQhvvl+kjXpQGmwZcpbOgmQ/g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026