UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04kZEeX1ZV4QkwTHXeP2pEmE2+l6XUT3y5EIyaTUyfA='
WHERE
key_id = '5d308bb0daef73ec2a4be3c8e20ca5fd44a77c803659aad7adf7a7f6c747b231'
AND (
token = '04kZEeX1ZV4QkwTHXeP2pEmE2+l6XUT3y5EIyaTUyfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)