UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hF4ziYqhjmYoUOFcG7S6bhISjVd4J7aX7EEluI4YmY0='
WHERE
key_id = '02b96df16d352fd0039db77933890cf6396a9f93f9e5fbe9ed084620fe59f5e4'
AND (
token = 'hF4ziYqhjmYoUOFcG7S6bhISjVd4J7aX7EEluI4YmY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)