UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QUOaXYZQodTeI/A+0ok0g9NtsWSPxKwKRaR4gNA6eDg='
WHERE
key_id = 'cc6f8cb769a919ac4c3a1db5ee6e82f712d11eb5724fa34acf075b110d1dece3'
AND (
token = 'QUOaXYZQodTeI/A+0ok0g9NtsWSPxKwKRaR4gNA6eDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)