UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47Cm5+H7rgyNRH5TB4qjCocaSNLy5ixTftU82bYIpAo='
WHERE
key_id = '12d723fa2c7d20dc872f9bd8ab47b08024f9fab71cd2675ec6736e5888ac5083'
AND (
token = '47Cm5+H7rgyNRH5TB4qjCocaSNLy5ixTftU82bYIpAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)