UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1bJN8i9wMcB9EBy/ANDEmO2t/TC15ixfn7ttxmLpYZg='
WHERE
key_id = '7fc07cf8119888c5376794eb06efb209543638e0436fd25cdd5922a8d7095f54'
AND (
token = '1bJN8i9wMcB9EBy/ANDEmO2t/TC15ixfn7ttxmLpYZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)