UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VA1q+WiQK2g9euQa0atdqJtGB7CPR2QCAHy5iQfbS+E='
WHERE
key_id = '521b4651faa5a674152700e327aed9cf691410f0e4cc58a1ae1f93aefc883f31'
AND (
token = 'VA1q+WiQK2g9euQa0atdqJtGB7CPR2QCAHy5iQfbS+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)