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())
)