UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnPWf6Df4+9hx2pftKKJnU4kK62mLdnFBMofhdHwqxA='
WHERE
key_id = '3db5d44a698d6b2108916fb97dc9ce87537fa47379913abd9d67bfc29450c158'
AND (
token = 'QnPWf6Df4+9hx2pftKKJnU4kK62mLdnFBMofhdHwqxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)