UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+knkNcHAKe3+x8fBTI69af2JKjt8xkbJKKPxZkb8OV0='
WHERE
key_id = 'a5f2f8af5c85f48bb65c04846e090953497888acb55a3b7fba33c2f8b4d38773'
AND (
token = '+knkNcHAKe3+x8fBTI69af2JKjt8xkbJKKPxZkb8OV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)