UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eq8nz+Z2jskhlDq/g6qcGFOGayml3fG+ZGnC4qjmjFU=' 
WHERE 
  key_id = '4ae8b44269f59d845890491359103191048d154340d6d872b3d865cc3ecfc5b1' 
  AND (
    token = 'eq8nz+Z2jskhlDq/g6qcGFOGayml3fG+ZGnC4qjmjFU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025