UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WgWXuwPwOVnDQMYa9/t+exMkv8NszVeEaD6u+d1xsks='
WHERE
key_id = 'a8ab8fc8fb3d3cd6e1e26df08b309c921fe198e46c6a91d6edd6105473c7b546'
AND (
token = 'WgWXuwPwOVnDQMYa9/t+exMkv8NszVeEaD6u+d1xsks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)