UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TfvQan+7SIuOwrZWkSnJe12nCFgJyKivEdw6aSMVN5c='
WHERE
key_id = '9213ced39f4eed7b9b106a2ac8a6bc1d219a66474322e0f39ae00bef59744c52'
AND (
token = 'TfvQan+7SIuOwrZWkSnJe12nCFgJyKivEdw6aSMVN5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)