This will need verification along the lines suggested in my comment. We may need to use SQL to create some test data to do the testing in Oracle.

I verified this by finding a book with no entry in xISBN (our external book finder) and entering incorrect metadata into the sample textbook provider. For example:

{
"seqnum" : "013",
"item_type" : "book",
"isbn" : "9781604502459",
"msrp" : null,
"on_reserve" : false,
"late_use" : false,
"edition_ok" : "N",
"author" : "H. G. Wells",
"comments" : "Comment for item 7 of 7. ISBN is 9781604502459\nNot on reserve. No late-use flag.\nMetadata may be scarce in xISBN.",
"required" : "REQ",
"edition" : "",
"publisher" : "Arc Manor",
"language" : "",
"title" : "The Island of Dr. Moreau",
"year" : "",
"location_city" : ""
}

The sample provider inserts the new data into the textbook_books table and marks it as expired. In the past, this entry would have appeared with a bogus title ("Book with ISBN 9781604502459") because the database entry is expired. It should display with title of "The Island of Dr. Moreau".

Since that entry was expired (even though it was just added), I was able to use the admin interface in the textbook tool to update (and renew) the entry so it has a different title and is unexpired.

Next, I tested with a book from the sample textbook provider that does have an entry in xISBN. I changed the entry coming from the provider so it had a bogus title ("This is a bogus title") and the entry already in the database so it has a bogus title ("BOGUS TITLE") and so it is expired. When the user navigated to the book list containing this book (either in the course site or in MyWorkspace), the database entry was updated to reflect the latest information from xISBN.