UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WiuyM0/7vkl1IHWusR9XnJr8z0JtfhHI9THY+f6OrE='
WHERE
key_id = '5af1374b0c412cab4974b29e3c1c521c69b4ed0c9560eb4a7ff20726a2f3662a'
AND (
token = '0WiuyM0/7vkl1IHWusR9XnJr8z0JtfhHI9THY+f6OrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)