UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ih5J5kgqXUPn+9MNvVA5g3oIt3S9ti/3sV2MFmZ6OmI=' 
WHERE 
  key_id = '64a9de40ba19b7d32aa51e51bb787a3243fa82844b7d0c05d95e3b1803b2dc9c' 
  AND (
    token = 'ih5J5kgqXUPn+9MNvVA5g3oIt3S9ti/3sV2MFmZ6OmI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026