UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JzNdIbLMxEKQ8RmRjVhayVfQXs2Kc5I4q1gN4k+chvc='
WHERE
key_id = '4dca4941d39cf7b5857ab61d26d0ae08ab77a9332d3918e707180bf2630c5cac'
AND (
token = 'JzNdIbLMxEKQ8RmRjVhayVfQXs2Kc5I4q1gN4k+chvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)