UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K9gBqm8X8/o7WFKHHe3MYRue0wde5A8KlGs3FdbM9sA='
WHERE
key_id = '5eafb5d2b9bebe69aaf3e17eda0918e1ced22e5efec750deff8ba91f6d324dea'
AND (
token = 'K9gBqm8X8/o7WFKHHe3MYRue0wde5A8KlGs3FdbM9sA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)