UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNjvOkzC6tIvlibT7LYj6xO7wPPgRfTagDmfK9VeeNo='
WHERE
key_id = '70472b58b55648fb16969fe29aa0656b5be377a5c92292a2d9c0a71a762b5c72'
AND (
token = 'tNjvOkzC6tIvlibT7LYj6xO7wPPgRfTagDmfK9VeeNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)