UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oI353UMcx6n0soIuwliQkcN/hiWtBf5IjRc8LH1yMDA=' 
WHERE 
  key_id = '84aa0992b06d5818c9a4de2241e2e3883b924fd243907dcc8c1df8b5d9fb22ac' 
  AND (
    token = 'oI353UMcx6n0soIuwliQkcN/hiWtBf5IjRc8LH1yMDA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028