UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'viN0cWLsV2Q30uI8DgEC8vfpemu3DGFvtnTex8g+isM=' 
WHERE 
  key_id = '5095da5ae82a62ac3beb0e1a7835c38ceafc3670595a86e4f147123837c2c2e9' 
  AND (
    token = 'viN0cWLsV2Q30uI8DgEC8vfpemu3DGFvtnTex8g+isM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036