UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H6DEjrMiL8r3CA6UIYlPeciFVSWScUjQsy6uEaHRtio='
WHERE
key_id = '69c4e709b71d9781dd0c1b07dadf4a0214b96f07145481d941d8ca5f1f7e6d13'
AND (
token = 'H6DEjrMiL8r3CA6UIYlPeciFVSWScUjQsy6uEaHRtio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)