UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y0gTY4fYdog50a3WWzrskLX06K7pwP7abOBg3CTvFGM='
WHERE
key_id = '64bdd212d62b0f9fe227b0420cf165eb518d95a9f9d29536daff4d57d01c0728'
AND (
token = 'Y0gTY4fYdog50a3WWzrskLX06K7pwP7abOBg3CTvFGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)