UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'L+FIH3dOlILBpnPae8yp4RnU1Dp+Mw0PxkYaUQLCLVE=' 
WHERE 
  key_id = '9e2345fdecf74adce45f341df05f2ea3868dc059e0eb95e403393e17bd204eab' 
  AND (
    token = 'L+FIH3dOlILBpnPae8yp4RnU1Dp+Mw0PxkYaUQLCLVE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036