UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nL/t4q2fzld2MrY5VhlhynnbXhT9qIkLLt1DcqV3CZU='
WHERE
key_id = 'afad84e2929e789083e5b18f4c8170f15c0df57976e74bce9f59c47f071b470c'
AND (
token = 'nL/t4q2fzld2MrY5VhlhynnbXhT9qIkLLt1DcqV3CZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)