UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J6ALKi2GSvy0mamH1N5vkliItZQXApttBwtiRn8qCV4='
WHERE
key_id = '68f4bbb7ac4d0ba94d291c9bf70775f5001db224b09ff32b81ddc31959538a84'
AND (
token = 'J6ALKi2GSvy0mamH1N5vkliItZQXApttBwtiRn8qCV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)