UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c42Ip6EkYLpUXtXI6WZmPJHu1aeLGnN2h0U5taRnNz0='
WHERE
key_id = 'afd242fdb4a3abdf6d15de072600de1bc490167df458db09a629bf58249faf2a'
AND (
token = 'c42Ip6EkYLpUXtXI6WZmPJHu1aeLGnN2h0U5taRnNz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)