Finally got it working! The
checkPass SQL statement needed to be changed to:
$conf['auth']['mysql']['checkPass'] =
"SELECT USER_PASSWORD AS pass
FROM ubbt_USERS
WHERE USER_LOGIN_NAME='%{user}'";
I now have DokuWiki authenticating against my UBB.threads installation!