UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xDctBknD63HD0qbI5CKRCMc8Q/YSrAjkn0ZOgPjJWns='
WHERE
key_id = '9f245b6165be630a173cbfe847d0df673a8a4d7be1086ccd010990b14a2b062c'
AND (
token = 'xDctBknD63HD0qbI5CKRCMc8Q/YSrAjkn0ZOgPjJWns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)