UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9cY3rtlOsKPot9dzpEztG2DpZRyPVTTOsrfjLizu64='
WHERE
key_id = '329513c97c2bef89ed9f823b6cdc7bdd2d96575de5935463946c941769a17bc0'
AND (
token = 'u9cY3rtlOsKPot9dzpEztG2DpZRyPVTTOsrfjLizu64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)