a checkbox field is stored as a serialized array, unless it’s a radio field. Sorry, it’s hard to tell from the explanation. anyway, for checkbox fields you’s need to use a “LIKE” query on the meta field. Unless it’s a true/false field, which looks like a checkbox, in this case see my previous comment.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users