UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uBFRL1HKvLR4OXDyTbWnLeZ6Jx7VQMDNPT0mbvmDirI=' 
WHERE 
  key_id = '391c248da5c8ef3f3664aa8e7d20a98e5cc9757e78415a162ad7d5c553ce6185' 
  AND (
    token = 'uBFRL1HKvLR4OXDyTbWnLeZ6Jx7VQMDNPT0mbvmDirI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020