UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jl6kJlu3+AG67KnKhALicqtK/Ntf4sWrZaLL4VGwOic='
WHERE
key_id = '9665c2529eeb9baa09906d07085604eac0dd2ac094cd921d5928d43b40fba41a'
AND (
token = 'jl6kJlu3+AG67KnKhALicqtK/Ntf4sWrZaLL4VGwOic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)