Is there a sql database engine that support "specific value duplicate restriction"?
Some DBMSes support indexes with a WHERE-condition

CREATE unique INDEX OnlyOneUnkownBrand
ON product (brand)
WHERE brand = 'unknown';