UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VuKhOq3wqGJVspQ8awMWZS2zk5Jv7RzNQuY4++FoZso='
WHERE
key_id = '48c81984281f6010ef909f6a55c52b7a41edb6c126ead229a4cf2c976574a6a3'
AND (
token = 'VuKhOq3wqGJVspQ8awMWZS2zk5Jv7RzNQuY4++FoZso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)