UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WTSt7SdKFM3Q3u/V2/Jf7u2FJfojdzU30wKsLzvGpAU=' 
WHERE 
  key_id = 'dee5ca1e90a7bd4e874ff464441c4515fb6803ac5888bff3cbe9d49191e5758d' 
  AND (
    token = 'WTSt7SdKFM3Q3u/V2/Jf7u2FJfojdzU30wKsLzvGpAU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026