UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PkqCB9URUS6YaNMg5q4d2ARirSKso8rqLB5k8VRqUAw='
WHERE
key_id = '80fe442ddf312f77f6a4abd5e2db1e86061a4b1beabfa6381e00620d51ccb36d'
AND (
token = 'PkqCB9URUS6YaNMg5q4d2ARirSKso8rqLB5k8VRqUAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)