UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'juDwtTGfJMTCDxU7pWRoWG9VUuq4q3eOQP6d50aI+1s=' 
WHERE 
  key_id = '66393b1e2b4c1919e5c54f14891be9c792832d24cf7a8381f2a4d357f1a37fb0' 
  AND (
    token = 'juDwtTGfJMTCDxU7pWRoWG9VUuq4q3eOQP6d50aI+1s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044