UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjw66V76IQQ7KhuGVEC8DKK/LQ6pDdJiMmlwH1mpPG0='
WHERE
key_id = '7670bc4df874d6782386cbbef788e503c73ab88c2aa904ead0abcefbecf40fd6'
AND (
token = 'hjw66V76IQQ7KhuGVEC8DKK/LQ6pDdJiMmlwH1mpPG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)