UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FTlt/s0ZcW/us1X8dg54G1jBvtn7ME5d+SoOtL0U7/o=' 
WHERE 
  key_id = 'eb2a3af08dc410b0d94ef4338b9d1deb605bb08a97bd33447382cbebb62a8df2' 
  AND (
    token = 'FTlt/s0ZcW/us1X8dg54G1jBvtn7ME5d+SoOtL0U7/o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048