Is it possible to avoid duplicate serial number just for item that are on stock?

Summary:

to avoid duplicate serial number just for item that are on stock

Content (please ensure you mask any confidential information):

We set differents item numbers for the same product representing its differents statuses like new, refurbushed, use, exhibition and other. All this statuses should use the same serial numb er but they never exist at the same time with stock, just one of the statuses will be on stock at the time. But also we need to avoid the serial numbers will be duplicated when there is on serial number with stock

Version (include the version you are using, if applicable):