UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i/1xhWGgiG1FxhHfnQMuOAV9pZuBvR+CYtsj+tMAddI='
WHERE
key_id = '16f0cb8ae47031d1a0615d4d3fe42fef6afa714f8026483022af60a42b2346ef'
AND (
token = 'i/1xhWGgiG1FxhHfnQMuOAV9pZuBvR+CYtsj+tMAddI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)