SELECT il.id
FROM instance_lockout_zone AS ilz
    LEFT JOIN instance_lockout AS il
        ON il.zone = ilz.zone AND il.version = ilz.version
WHERE ilz.charid = 1234
    AND il.id = 31