UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l7Aer4Q3uFxUoY5pQE+536iE07oW2BRxPJap0Tz88qs='
WHERE
key_id = '8ff7e22148caf179fd568f291afcd16fb1d46d3a6779d9477c3ba07d24b8a9c8'
AND (
token = 'l7Aer4Q3uFxUoY5pQE+536iE07oW2BRxPJap0Tz88qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)