UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dh5oiINQ9S/Gc2RyfQng45UL10GkKfCJWXmGiUwkFM='
WHERE
key_id = 'c7678c9f48f7652f79387687a066f31b22c5aadd47a2a44e4296007f9b575ccb'
AND (
token = '8dh5oiINQ9S/Gc2RyfQng45UL10GkKfCJWXmGiUwkFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)