UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JFm8WEUnQFZwgWreyH5l1DVWjziPQEkWA6jt42R0An8='
WHERE
key_id = '366f1eccedd27583d90f847e808f1b13ef002cc486e4c6dd3473dc0d82d6db7c'
AND (
token = 'JFm8WEUnQFZwgWreyH5l1DVWjziPQEkWA6jt42R0An8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)