UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDMrDw49lbM6Pv/JE9QzNrIIK+XXVeB6zcnBsufOQvU='
WHERE
key_id = '817307c40ec1ecdc21dadfbf949628dcd158d4ca140f49c268fc23e22b5db79b'
AND (
token = 'ZDMrDw49lbM6Pv/JE9QzNrIIK+XXVeB6zcnBsufOQvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)