UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GLdBZfsc0yH3e49yufe/UK9K81TPUDd6ZM4SPB3sxwY='
WHERE
key_id = 'aa3d2e60cd9acbaa985f8e826904f2042300b8b051438217af26e55b207c059c'
AND (
token = 'GLdBZfsc0yH3e49yufe/UK9K81TPUDd6ZM4SPB3sxwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)