UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RVNwPVmHj+7x1JlfzSTXTTa/HwnW4gyzzA7h7yaNVW0='
WHERE
key_id = '8451180af8664b89ae6500a54d36bb10d4b721b016d4fab078c09ebc7e18bfef'
AND (
token = 'RVNwPVmHj+7x1JlfzSTXTTa/HwnW4gyzzA7h7yaNVW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)