UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xidw2saTNQEO5DesjVCHkQpUlu6v5C4l458ZQPUvpsU=' 
WHERE 
  key_id = 'f186bc62bc9d4c83ccd214dbb7769fa3a3b6c83b59d00ecac208cc7218a84d5c' 
  AND (
    token = 'xidw2saTNQEO5DesjVCHkQpUlu6v5C4l458ZQPUvpsU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028