MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename (
  ID INTEGER,
  x1 INTEGER,
  x2 INTEGER,
  x3 INTEGER,
  x4 INTEGER,
  x5 INTEGER
);

INSERT INTO tablename VALUES
  (1, 0, 0, 1, 1, 1),
  (1, 0, 0, 0, 1, 1),
  (1, 1, 0, 0, 1, 1),
  (2, 1, 1, 0, 0, 0),
  (2, 1, 0, 0, 0, 0);
SELECT t1.*
FROM tablename t1
WHERE NOT EXISTS (
  SELECT *
  FROM tablename t2
  WHERE t2.ID = t1.ID 
    AND (t1.x1, t1.x2, t1.x3, t1.x4, t1.x5) <>
        (t2.x1, t2.x2, t2.x3, t2.x4, t2.x5)
    AND CONV(CONCAT(t1.x1, t1.x2, t1.x3, t1.x4, t1.x5), 2, 10) |
        CONV(CONCAT(t2.x1, t2.x2, t2.x3, t2.x4, t2.x5), 2, 10) =
        CONV(CONCAT(t2.x1, t2.x2, t2.x3, t2.x4, t2.x5), 2, 10)
);


ID
x1
x2
x3
x4
x5


1
0
0
1
1
1

1
1
0
0
1
1

2
1
1
0
0
0


WITH cte AS (
  SELECT *, CONV(CONCAT(x1, x2, x3, x4, x5), 2, 10) value
  FROM tablename
)
SELECT t1.ID, t1.x1, t1.x2, t1.x3, t1.x4, t1.x5
FROM cte t1
WHERE NOT EXISTS (
  SELECT *
  FROM cte t2
  WHERE t2.ID = t1.ID 
    AND t2.value <> t1.value
    AND t1.value | t2.value = t2.value
);


ID
x1
x2
x3
x4
x5


1
0
0
1
1
1

1
1
0
0
1
1

2
1
1
0
0
0


DELETE t1
FROM tablename t1 INNER JOIN tablename t2
ON t2.ID = t1.ID
AND (t1.x1, t1.x2, t1.x3, t1.x4, t1.x5) <>
    (t2.x1, t2.x2, t2.x3, t2.x4, t2.x5)
AND CONV(CONCAT(t1.x1, t1.x2, t1.x3, t1.x4, t1.x5), 2, 10) |
    CONV(CONCAT(t2.x1, t2.x2, t2.x3, t2.x4, t2.x5), 2, 10) =
    CONV(CONCAT(t2.x1, t2.x2, t2.x3, t2.x4, t2.x5), 2, 10);
SELECT * FROM tablename;


ID
x1
x2
x3
x4
x5


1
0
0
1
1
1

1
1
0
0
1
1

2
1
1
0
0
0