UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8bQVIFRkC6+4gGnBSo1bv+oAifYHIT8FxKy38qTwSw='
WHERE
key_id = '58aae7ba93ef370a319ff0871d73b46ffbf1d1ea690d1ff43c3e586940c38596'
AND (
token = 'a8bQVIFRkC6+4gGnBSo1bv+oAifYHIT8FxKy38qTwSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)